UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5bZRJQhquA1mio8M91kJbyM8Bo2uGxcdi1ebWtyXEuI='
WHERE
key_id = '1499933f7d20105c9c0eee8511a86b5f278d3c01029f235676075790f40a097a'
AND (
token = '5bZRJQhquA1mio8M91kJbyM8Bo2uGxcdi1ebWtyXEuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)