UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZHxp+UWpDes6hZZn/sHkbtfMEn5ylbl7Rslph6G3EU='
WHERE
key_id = 'e7046e92681de2b31e69b425107a65ead462896e07bb6f806a0b3897e528c76c'
AND (
token = 'bZHxp+UWpDes6hZZn/sHkbtfMEn5ylbl7Rslph6G3EU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)