UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9+WecfvzfxXOVGz5j/qg/zoKTL09z1Jicp3xdiacNo='
WHERE
key_id = 'c21da0dc0d0d3f49b741980be8d7a5434b2f1573e9aefa9a7a29fa850646067a'
AND (
token = 'n9+WecfvzfxXOVGz5j/qg/zoKTL09z1Jicp3xdiacNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)