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