UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5Dk6h814Do9OzLRytTWqiXiV87/r+e3LkgVLrMUgpU='
WHERE
key_id = 'beb0471f6802063dca8d692a0f1bfb87027ab38e0105848f54bbb3cd2582556d'
AND (
token = 'N5Dk6h814Do9OzLRytTWqiXiV87/r+e3LkgVLrMUgpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)