UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PnvRng5BZzTPG+nyxgnphKyWv+UdMz21Ou7Wj/4Yz+o='
WHERE
key_id = '0b4888754c0c9c3787fb4de6b7ecb5a2489c86820daa6eacf04c3f2270b8076d'
AND (
token = 'PnvRng5BZzTPG+nyxgnphKyWv+UdMz21Ou7Wj/4Yz+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)