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