UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rHj78ujYAMNGLB9voDlwshBjtcFVd5MpikucxgfSuUY='
WHERE
key_id = '5f4c16164ed95c65127bf9aff8023ae873191a4006056c854cf2a0fcb0017e6d'
AND (
token = 'rHj78ujYAMNGLB9voDlwshBjtcFVd5MpikucxgfSuUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)