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