UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zDK3Jri7uWrJcuxtNdLUDOKq1rUUGmvhndm3yuFchg='
WHERE
key_id = '06bfd9e4e387215933ce879b061973fccdac9828b9ddc2dedfdcbee3a8b5bbb0'
AND (
token = '5zDK3Jri7uWrJcuxtNdLUDOKq1rUUGmvhndm3yuFchg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)