UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ze1p5FhAU8bg3fF6AwevuwG3Cad7lWaq40vY9gxrI0='
WHERE
key_id = '3042c282f69f8f0b9219a1ebfc0f9cd6e65c39d4f707233dcc9793e73a7fb57a'
AND (
token = '3ze1p5FhAU8bg3fF6AwevuwG3Cad7lWaq40vY9gxrI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)