UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFAD9T+eGJ3G96GPT/5GeaMv/+UL2K8A2BQ/UjWHDfo='
WHERE
key_id = '0d67acea942e111f7b60df55a601299c353f41fc5d22eeab161470fa317a6b9a'
AND (
token = 'XFAD9T+eGJ3G96GPT/5GeaMv/+UL2K8A2BQ/UjWHDfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)