UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvivzglY78oKSgv14G5s8sPjo9s4q7BGzVNb5y43Lr8='
WHERE
key_id = '9248d738c2625494f9cbc288e7ab6a9f2054f095c6009e821b02b0d493965249'
AND (
token = 'pvivzglY78oKSgv14G5s8sPjo9s4q7BGzVNb5y43Lr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)