UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4f5fH0OVQYXvnV3SBbbsYYxkFUOYeLjVzfJLtcAQDZk='
WHERE
key_id = '1b614a6ff829cd5685179a101ff4cb54371e98305504214d3cdb41f68e1a9cc7'
AND (
token = '4f5fH0OVQYXvnV3SBbbsYYxkFUOYeLjVzfJLtcAQDZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)