UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dP0EjV1BeO5VjRxY2MfRpn/X+drovPJYKoAsE60fbw='
WHERE
key_id = 'fd8faa431b181b171c4ce9f0e5c8edaf56927002cecd5c5b7e795881744cd0ee'
AND (
token = '7dP0EjV1BeO5VjRxY2MfRpn/X+drovPJYKoAsE60fbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)