UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJm7iTo0ejr+WvWt9SA5r0cySYOoMHYahNFcQKUrVwo='
WHERE
key_id = '0cd71cada2a410df5ca846558c9492f711261c99205c3c731ccc2352b95a40bf'
AND (
token = 'bJm7iTo0ejr+WvWt9SA5r0cySYOoMHYahNFcQKUrVwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)