UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y9AHs6FK2JaYUDnG/xkLtZdT2QQ+mwTD7LLHwWBEgmA='
WHERE
key_id = 'd7ec1a1bb7ce17b89c65966c8fe7f2a3f9f6cd5f47d359c9831e67e36bef6156'
AND (
token = 'y9AHs6FK2JaYUDnG/xkLtZdT2QQ+mwTD7LLHwWBEgmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)