UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZG7AYV1PavCJ3upb+tvflYsBAArPx0tvVNCjq4FAiQ='
WHERE
key_id = '1b6df34e313aedc7347c948bc1a842b83b280f410af18dcc8661444bab72b339'
AND (
token = 'pZG7AYV1PavCJ3upb+tvflYsBAArPx0tvVNCjq4FAiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)