UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XvN/DvPbgSghNLNJpAEXAabIknYk4vk1GWZNG5DZko='
WHERE
key_id = 'a23b379f1804682ab40454a0e303d4717cb86a84976e6303d90dd80a92404679'
AND (
token = '/XvN/DvPbgSghNLNJpAEXAabIknYk4vk1GWZNG5DZko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)