UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I1zWkBaJkHXDUK7kRK8fg+zBBvrbR/rRiE5fQvm/dbc='
WHERE
key_id = 'de42e90150a62720ce307abf29921e8ceef8f089bdd6d77d725d51df391b1a33'
AND (
token = 'I1zWkBaJkHXDUK7kRK8fg+zBBvrbR/rRiE5fQvm/dbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)