UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jk0ldqMJMhqD0/2egw5XECrYTMj+kV2c0Kle6fnGQcw='
WHERE
key_id = 'a42c6a878129b3a4cc446ea0961b92ff47a08409b9dd4d89e38dc733f995d544'
AND (
token = 'Jk0ldqMJMhqD0/2egw5XECrYTMj+kV2c0Kle6fnGQcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)