UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMAxIDxsCH5ACYn1LQ8oqzWaY/TWYkQ176Tp6WpJ40w='
WHERE
key_id = 'cca1a7cf92476b23ef9aaccf3273dd2f9c6e44ca198b1372c265292181536426'
AND (
token = 'sMAxIDxsCH5ACYn1LQ8oqzWaY/TWYkQ176Tp6WpJ40w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)