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