UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YgURVd2wS8LPSpXciqy/cXvch3j5/0wv72kctxw1F0w='
WHERE
key_id = '1fcd3aac029719a812269e5962c1b3c1ec2175bbb67295e114325d418aa48c6a'
AND (
token = 'YgURVd2wS8LPSpXciqy/cXvch3j5/0wv72kctxw1F0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)