UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oi1OHPkR63FueGGLHrqdu3CTUX/MY2m+2BjYthw1NyU='
WHERE
key_id = 'f38da2d4691606d1452437eadc5f1f9e14853408eca85c8ae385cf9df26ad415'
AND (
token = 'oi1OHPkR63FueGGLHrqdu3CTUX/MY2m+2BjYthw1NyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)