UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iIk6+NFc3o6XCxnJOMKmgBDalfaK39Mj97t9b69OiHs='
WHERE
key_id = 'f4d661a7bed80b9a01284cca50a7cda97255e581797826a4f9eca4c413cc7a4b'
AND (
token = 'iIk6+NFc3o6XCxnJOMKmgBDalfaK39Mj97t9b69OiHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)