UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zA0MvvMXS72UhGWTO2+KtfTQK6I2VO+dkMKTtG/EBo4='
WHERE
key_id = '801a586492e0f8799af28911cce5978e665c9a4cfa27fdd11ebcf7b834064186'
AND (
token = 'zA0MvvMXS72UhGWTO2+KtfTQK6I2VO+dkMKTtG/EBo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)