UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rCA8NC0RxZxV2zADqBjECm27cduuJ3UCyGUhc3U/SA='
WHERE
key_id = '55aff9dd368d297d2686b3d47c63fccead2ded1992e35b6350857a4feb5faf70'
AND (
token = '9rCA8NC0RxZxV2zADqBjECm27cduuJ3UCyGUhc3U/SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)