UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIKHM21TtAzN6dB+oC4slGfvZlBjRlaRGSqDyWC2FtA='
WHERE
key_id = '3214b8ee37b4a245a744008fb540d913251811ea712b1d61f1971d01c90265fb'
AND (
token = 'zIKHM21TtAzN6dB+oC4slGfvZlBjRlaRGSqDyWC2FtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)