UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kPhnMDDrSnQHB1I2rqgnVFWa2c3IOGDTYBlB7IP++sA='
WHERE
key_id = '46aea8d441e00b7f4d0b43b946fd00b925fa3a68940f33299effff15a9e4d3e1'
AND (
token = 'kPhnMDDrSnQHB1I2rqgnVFWa2c3IOGDTYBlB7IP++sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)