UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gLRs7CD5y7LPJN9CddWzky81mA6qb34agjz6Gulj94='
WHERE
key_id = '43de52d0b4ef74605be978fb86e8980b04f126096b6d495dfce196488de18ad9'
AND (
token = '7gLRs7CD5y7LPJN9CddWzky81mA6qb34agjz6Gulj94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)