UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PJkg9bXgntmuO+L3g2j9ODzxbrE+SZRky7cmOc3J8NE='
WHERE
key_id = '9cf9abc699525c7fa4120218ed8cf772043db4220cf76ec1d771322d30d3db80'
AND (
token = 'PJkg9bXgntmuO+L3g2j9ODzxbrE+SZRky7cmOc3J8NE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)