UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7UEgqZexD7YcXN0FqGUES9CB89HXk4F3TLSHBnPeN4='
WHERE
key_id = 'ac390edbe259a7d498e1202e946e0096bef57abb193c7b52ed50ca1383958323'
AND (
token = 'k7UEgqZexD7YcXN0FqGUES9CB89HXk4F3TLSHBnPeN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)