UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1zSxzAP3qqmWgnznO33kRz1vZ4NRvS6ty6WayxAou4w='
WHERE
key_id = '947ec5c9e14dfb65be3152c629237b3ca9725ffa86dc2c41fc3d634bd1586cdf'
AND (
token = '1zSxzAP3qqmWgnznO33kRz1vZ4NRvS6ty6WayxAou4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)