UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqX+6RrruGXcBReEldUufCTK63YtKWLFL/KLoGi9YxM='
WHERE
key_id = '3cde12f2c258d201b0c4d50c038ec00c5bc07473d5b69585814a2a19afa1581b'
AND (
token = 'xqX+6RrruGXcBReEldUufCTK63YtKWLFL/KLoGi9YxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)