UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ViCeTg67svMP0dh6VkEjfUyKdxpbsP5Om++pwE4VCU='
WHERE
key_id = 'cad2d21b32ec26441fbc6a90f0b397b6bfccb3d1aaae703014050e891f509aea'
AND (
token = '+ViCeTg67svMP0dh6VkEjfUyKdxpbsP5Om++pwE4VCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)