UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmNE9cY6x/GHT+vcGzuVAsMny4saj+Q8glp1jRtEyM8='
WHERE
key_id = '3a936c315f274b26e6434f72e28990c2c297bb4360d0b5c0446caad82b004199'
AND (
token = 'CmNE9cY6x/GHT+vcGzuVAsMny4saj+Q8glp1jRtEyM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)