UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EBPT9rmwxyk2TpxpZ4xlFU2CKyijSA9a1m2JjZrPa5g='
WHERE
key_id = '3a1a55386ec4e19dfce88a717c7cd95adaf5b66317aaa41ec2a1a1fef32a747a'
AND (
token = 'EBPT9rmwxyk2TpxpZ4xlFU2CKyijSA9a1m2JjZrPa5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)