UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcG3ute8P8ATQRl11m/jnRqoomRQ8tkZcnf5sPn9CI0='
WHERE
key_id = '97e6c69923698182d2293bb50bd0c365e82460e665dab344be8aaa047c6f91d5'
AND (
token = 'XcG3ute8P8ATQRl11m/jnRqoomRQ8tkZcnf5sPn9CI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)