UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K8AMkd03fNvjLyGj6uCx8mKBRom4EFGn9kXVkluVMs4='
WHERE
key_id = '0a1250d2366fc9f9618b241e8c0847313275c8ea2f9d2169bea240fc38da8ee8'
AND (
token = 'K8AMkd03fNvjLyGj6uCx8mKBRom4EFGn9kXVkluVMs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)